package jdbc;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class LoginDemo {
    public static void main(String[] args) {
        UserInfo userInfo=InputUtil.getInputObject(new UserInfo(),"欢迎登陆!","登陆");
        try (Connection connection=DBUtil.getConnection()){
            Statement statement=connection.createStatement();
            String sql="SELECT username,password,nickname "+
                       "FROM userinfo "+
                       "WHERE username='"+userInfo.getUsername()+"' AND password= "+userInfo.getPassword();
            System.out.println(sql);
            ResultSet rs=statement.executeQuery(sql);
            if (rs.next()){
                System.out.println("登陆成功!欢迎你"+userInfo.getNickname());
            }else {
                System.out.println("登陆失败,用户名或密码不正确");
            }
        }catch (SQLException e){
            e.printStackTrace();
        }
    }
}